package com.kfm.springmybatis.dao;

import com.kfm.springmybatis.model.Emp;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface EmpMapper {
    /**
     * insert record to table
     * @param record the record
     * @return insert count
     */
    int insert(Emp record);

    /**
     * insert record to table selective
     * @param record the record
     * @return insert count
     */
    int insertSelective(Emp record);

    /**
     *一对一多表查询
     * @return
     */
    List<Emp> selectAll();

    /**
     *一对一多表查询
     * @return
     */
    List<Emp> selectAll2();

    List<Emp> selectAll3();

    List<Emp> selectByDeptNo(Integer deptNo);

}